How to import and export data in SQL server from different file format

Question

Pravesh Singh · Answer

Hi Arun Singh,Yes! SQL server has an option to resolve this problem. To import data from text file in SQL table, you can use Bulk Query command. Let's take a look of this command.BULK INSERT table_Name FROM 'c:\fileName.txt' WITH (FIELDTERMINATOR = ',')I hope it might be useful for you.and

forum

How to import and export data in SQL server from different file format

Anonymous User

Can you answer this question?

1 Answers

Liked By